
**cd "location"

capture log close

log using "descriptives Tables 1-3.log", replace
use "QATARAID_RAW.dta" ,clear
tab country
**1411 operations
sort country
keep country
duplicates drop
drop if country=="."
tab country
***128 countries

use "QATARAID_RAW.dta" ,clear
tab country if bilatereal==1
dis 1305-9
*1296 aims a specific location
*122-1 countries

tab country if bilatereal==0
dis 95-27
*68
* We observe 95 multilateral aid operations out of them 68 of them targets a specific location.

**Table 1
 tab dumregion year, col nofreq
 
**Table 2. Distribution of Qatar's foreign aid by sector (2014–2021)
tab sector_description , sort

use "QATARAID_PANEL.dta", clear
tab year
tab country
sort country
by country: egen cmeanaidinteractions=mean( aidinteractions)
tab country if cmeanaidinteractions==0
dis 544/8
*68 countries

**Table 3. Descriptive Statistics (2014–2021) 
use "QATARAID_PANEL_ESTIMATIONS.dta", clear
sum aidinteractions aidstatus political_interests qatarblockade polity2 v2x_polyarchy mediation_new muslimmajority arableague ln_qatarimports_un_v2 ln_qatarexports_un_v2 ln_qatartrade  ln_gdp_per_capita_WB gdppc_growth lninfant ln_pop qatardistance
 
log close